package com.yw.swagger.mapper;

import com.yw.swagger.model.SpNotice;
import com.yw.swagger.model.SpNoticeFile;
import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Repository;

import java.util.List;
import java.util.Map;

/**
 * Created by 14267 on 2019/10/24
 */
@Repository
public interface SpNoticeMapper {
    public List<SpNotice> selectNoticesAllList();
    public List<SpNotice> selectNoticesList(SpNotice spNotice);
    public List<SpNotice> selectNoticesAnswerList(SpNotice spNotice);
    public SpNotice selectNoticeInfoByNoticeId(@Param("noticeId") String noticeId, @Param("toUser") String toUser);
    public List<SpNotice> selectNoticeFromInfoByNoticeId(@Param("noticeId") String noticeId);
    public List<SpNoticeFile> selectNoticeFileByNoticeId(String noticeId);
    public int addNotice(SpNotice spNotice);
    public int addNoticeFile(SpNoticeFile spn);
    public int delNoticeTo(@Param("noticeId") String noticeId, @Param("toUser") String toUser);
    public int deleteByIds(@Param("noticeIds") String[] noticeIds, @Param("toUser") String toUser);
    public int setAnswer(SpNotice spNotice);
























    List<Map<String,Object>>selectSysBps();

    List<Map<String,Object>> selectSysBpsG(int id);
}
